Release 10.1A: OpenEdge Development:
Progress 4GL Reference

+ Date addition operator

Adds a number of days to a date, producing a date result.

Syntax

date + days

date

An expression that evaluates to a DATE value.

days

An expression with a value of the number of days you want to add to a date.

Example

This procedure finds all unshipped orders that are at least one week overdue. If the order is not shipped and the promised date is more than seven days ago, the procedure finds the record for the customer who placed the order and displays the order and customer data.

r-dadd.p

DISPLAY "ORDERS SCHEDULED TO SHIP MORE THAN ONE WEEK LATE". FOR EACH order WHERE ship-date = ?: IF TODAY > (promise-date + 7) THEN DO: FIND customer OF order. DISPLAY order.order-num order.cust-num customer.name promise-date customer.terms. END. END.

Notes

The date addition operator rounds days to the nearest integer value.
To add a specific number of days or a specific number of milliseconds to a DATETIME, use the DATETIME function. For example:

new-datetime = DATETIME( DATE(old-datetime) + days,   MTIME(old-datetime) + milliseconds ).

The DATETIME function ensures that the time portion remains within the valid range, by adding day(s) to the date part when the time part goes over the number of milliseconds in a day.

To add a specific number of days or milliseconds to a DATETIME-TZ, use the DATETIME-TZ function. For example:

new-datetime-tz = DATETIME-TZ( DATE(old-datetime-tz) + days,   MTIME (old-datetime-tz) + milliseconds, TIMEZONE(old-dateime-tz)).

The DATETIME-TZ function ensures that the time portion remains within the valid range, by adding day(s) to the date portion when the time part goes over the number of milliseconds in a day.